<cfcomponent extends="assets.calgrants.com.Base">

	<cfscript>
        import assets.calgrants.com.bo.Payment;
	</cfscript>
	
	<cffunction name="get" access="public" output="false" returntype="assets.calgrants.com.bo.Payment">
		<cfargument name="Payment_ID" type="numeric" required="true" />
		<cfscript>
			if (arguments.Payment_ID gt 0) {
				local.loadArgs = {};
				local.loadArgs.obj = new Payment();
				StructAppend(local.loadArgs, QueryToStruct(read(argumentCollection = arguments))[1]);
				return load(argumentCollection = local.loadArgs);
			} else {
				return new Payment();
			}
		</cfscript>
	</cffunction>

	<cffunction name="load" access="public" output="false" returntype="assets.calgrants.com.bo.Payment">
		<cfargument name="obj" type="assets.calgrants.com.bo.Payment" required="true" />
		<cfscript>
			local.obj = arguments.obj;
			if (IsDefined("arguments.Payment_ID")) {
				local.obj.setPayment_ID(arguments.Payment_ID);
			}
			if (IsDefined("arguments.Scholarship_ID")) {
				local.obj.setScholarship_ID(arguments.Scholarship_ID);
			}
			if (IsDefined("arguments.Payment_Schedule_ID")) {
				local.obj.setPayment_Schedule_ID(arguments.Payment_Schedule_ID); 
			}
			if (IsDefined("arguments.Deleted")) {
				local.obj.setDeleted(arguments.Deleted); 
			}
			if (IsDefined("arguments.Opt_Out")) {
				local.obj.setOpt_Out(arguments.Opt_Out); 
			}
			if (IsDefined("arguments.Opt_Out_Reason")) {
				local.obj.setOpt_Out_Reason(arguments.Opt_Out_Reason); 
			}
			if (IsDefined("arguments.Institution1_ID")) {
				local.obj.setInstitution1_ID(arguments.Institution1_ID); 
			}
			if (IsDefined("arguments.Institution1_Document_Date")) {
				local.obj.setInstitution1_Document_Date(arguments.Institution1_Document_Date); 
			}
			if (IsDefined("arguments.Institution1_Enrollment_Units")) {
				local.obj.setInstitution1_Enrollment_Units(arguments.Institution1_Enrollment_Units); 
			}
			if (IsDefined("arguments.Institution1_Enrollment_Attendance_Level")) {
				local.obj.setInstitution1_Enrollment_Attendance_Level(arguments.Institution1_Enrollment_Attendance_Level); 
			}
			if (IsDefined("arguments.Institution1_Enrollment_Degree_Level")) {
				local.obj.setInstitution1_Enrollment_Degree_Level(arguments.Institution1_Enrollment_Degree_Level); 
			}
			if (IsDefined("arguments.Institution1_Performance_Credits")) {
				local.obj.setInstitution1_Performance_Credits(arguments.Institution1_Performance_Credits); 
			}
			if (IsDefined("arguments.Institution1_Performance_GPA")) {
				local.obj.setInstitution1_Performance_GPA(arguments.Institution1_Performance_GPA); 
			}
			if (IsDefined("arguments.Institution2_ID")) {
				local.obj.setInstitution2_ID(arguments.Institution2_ID); 
			}
			if (IsDefined("arguments.Institution2_Document_Date")) {
				local.obj.setInstitution2_Document_Date(arguments.Institution2_Document_Date); 
			}
			if (IsDefined("arguments.Institution2_Enrollment_Units")) {
				local.obj.setInstitution2_Enrollment_Units(arguments.Institution2_Enrollment_Units); 
			}
			if (IsDefined("arguments.Institution2_Enrollment_Attendance_Level")) {
				local.obj.setInstitution2_Enrollment_Attendance_Level(arguments.Institution2_Enrollment_Attendance_Level); 
			}
			if (IsDefined("arguments.Institution2_Enrollment_Degree_Level")) {
				local.obj.setInstitution2_Enrollment_Degree_Level(arguments.Institution2_Enrollment_Degree_Level); 
			}
			if (IsDefined("arguments.Institution2_Performance_Credits")) {
				local.obj.setInstitution2_Performance_Credits(arguments.Institution2_Performance_Credits); 
			}
			if (IsDefined("arguments.Institution2_Performance_GPA")) {
				local.obj.setInstitution2_Performance_GPA(arguments.Institution2_Performance_GPA); 
			}
			if (IsDefined("arguments.Institution3_ID")) {
				local.obj.setInstitution3_ID(arguments.Institution3_ID); 
			}
			if (IsDefined("arguments.Institution3_Document_Date")) {
				local.obj.setInstitution3_Document_Date(arguments.Institution3_Document_Date); 
			}
			if (IsDefined("arguments.Institution3_Enrollment_Units")) {
				local.obj.setInstitution3_Enrollment_Units(arguments.Institution3_Enrollment_Units); 
			}
			if (IsDefined("arguments.Institution3_Enrollment_Attendance_Level")) {
				local.obj.setInstitution3_Enrollment_Attendance_Level(arguments.Institution3_Enrollment_Attendance_Level); 
			}
			if (IsDefined("arguments.Institution3_Enrollment_Degree_Level")) {
				local.obj.setInstitution3_Enrollment_Degree_Level(arguments.Institution3_Enrollment_Degree_Level); 
			}
			if (IsDefined("arguments.Institution3_Performance_Credits")) {
				local.obj.setInstitution3_Performance_Credits(arguments.Institution3_Performance_Credits); 
			}
			if (IsDefined("arguments.Institution3_Performance_GPA")) {
				local.obj.setInstitution3_Performance_GPA(arguments.Institution3_Performance_GPA); 
			}
			if (IsDefined("arguments.Approval_Date")) {
				local.obj.setApproval_Date(arguments.Approval_Date); 
			}
			if (IsDefined("arguments.Payment_Submitted_Date")) {
				local.obj.setPayment_Submitted_Date(arguments.Payment_Submitted_Date); 
			}
			if (IsDefined("arguments.Payment_Date")) {
				local.obj.setPayment_Date(arguments.Payment_Date); 
			}
			if (IsDefined("arguments.Payment_Type")) {
				local.obj.setPayment_Type(arguments.Payment_Type); 
			}
			if (IsDefined("arguments.Payment_Amount")) {
				local.obj.setPayment_Amount(arguments.Payment_Amount); 
			}
			if (IsDefined("arguments.Payment_Reference")) {
				local.obj.setPayment_Reference(arguments.Payment_Reference); 
			}
			if (IsDefined("arguments.Notes")) {
				local.obj.setNotes(arguments.Notes); 
			}
			if (IsDefined("arguments.Date_Created")) {
				local.obj.setDate_Created(arguments.Date_Created);
			}			
			return local.obj;
		</cfscript>
	</cffunction>
	
	<cffunction name="read" access="public" output="false" returntype="any">
		<cfargument name="Payment_ID" required="false" default="" />
		<cfargument name="Scholarship_ID" required="false" default="" />
		<cfargument name="Payment_Schedule_ID" required="false" default="" />
		<cfargument name="Deleted" required="false" default="0" />
		<cfargument name="Opt_Out" required="false" default="" />
		<cfargument name="Opt_Out_Reason" required="false" default="" />
		<cfargument name="Institution1_ID" required="false" default="" />
		<cfargument name="Institution1_Document_Date" required="false" default="" />
		<cfargument name="Institution1_Enrollment_Units" required="false" default="" />
		<cfargument name="Institution1_Enrollment_Attendance_Level" required="false" default="" />
		<cfargument name="Institution1_Enrollment_Degree_Level" required="false" default="" />
		<cfargument name="Institution1_Performance_Credits" required="false" default="" />
		<cfargument name="Institution1_Performance_GPA" required="false" default="" />
		<cfargument name="Institution2_ID" required="false" default="" />
		<cfargument name="Institution2_Document_Date" required="false" default="" />
		<cfargument name="Institution2_Enrollment_Units" required="false" default="" />
		<cfargument name="Institution2_Enrollment_Attendance_Level" required="false" default="" />
		<cfargument name="Institution2_Enrollment_Degree_Level" required="false" default="" />
		<cfargument name="Institution2_Performance_Credits" required="false" default="" />
		<cfargument name="Institution2_Performance_GPA" required="false" default="" />
		<cfargument name="Institution3_ID" required="false" default="" />
		<cfargument name="Institution3_Document_Date" required="false" default="" />
		<cfargument name="Institution3_Enrollment_Units" required="false" default="" />
		<cfargument name="Institution3_Enrollment_Attendance_Level" required="false" default="" />
		<cfargument name="Institution3_Enrollment_Degree_Level" required="false" default="" />
		<cfargument name="Institution3_Performance_Credits" required="false" default="" />
		<cfargument name="Institution3_Performance_GPA" required="false" default="" />
		<cfargument name="Approval_Date" required="false" default="" />
		<cfargument name="Payment_Submitted_Date" required="false" default="" />
		<cfargument name="Payment_Date" required="false" default="" />
		<cfargument name="Payment_Type" required="false" default="" />
		<cfargument name="Payment_Amount" required="false" default="" />
		<cfargument name="Payment_Reference" required="false" default="" />
		<cfargument name="Notes" required="false" default="" />
		<cfargument name="Date_Created" required="false" default="" />
		<cfargument name="authorized" required="false" default="" />
		<cfargument name="cohort" required="false" default="" />
		<cfargument name="scholarshipType" required="false" default="" />
		<cfargument name="scholarshipTypes" required="false" default="" />
		<cfargument name="term" required="false" default="" />
		<cfargument name="termType" required="false" default="" />
		<cfargument name="verificationType" required="false" default="" />
		<cfargument name="statuses" required="false" default="" />

		<cfset var recs = "">
		<cfstoredproc datasource="#getDatasource()#" procedure="readPayment">
			<cfprocparam value="#arguments.Payment_ID#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(arguments.Payment_ID)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Scholarship_ID#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(arguments.Scholarship_ID)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Payment_Schedule_ID#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(arguments.Payment_Schedule_ID)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Deleted#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(arguments.Deleted)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Opt_Out#" cfsqltype="CF_SQL_BIT" null="#IIf(Len(Trim(arguments.Opt_Out)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Opt_Out_Reason#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Opt_Out_Reason)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution1_ID#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(arguments.Institution1_ID)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution1_Document_Date#" cfsqltype="CF_SQL_DATE" null="#IIf(Len(Trim(arguments.Institution1_Document_Date)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution1_Enrollment_Units#" cfsqltype="CF_SQL_INT" null="#IIf(Len(Trim(arguments.Institution1_Enrollment_Units)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution1_Enrollment_Attendance_Level#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Institution1_Enrollment_Attendance_Level)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution1_Enrollment_Degree_Level#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Institution1_Enrollment_Degree_Level)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution1_Performance_Credits#" cfsqltype="CF_SQL_INT" null="#IIf(Len(Trim(arguments.Institution1_Performance_Credits)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution1_Performance_GPA#" cfsqltype="CF_SQL_INT" null="#IIf(Len(Trim(arguments.Institution1_Performance_GPA)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution2_ID#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(arguments.Institution2_ID)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution2_Document_Date#" cfsqltype="CF_SQL_DATE" null="#IIf(Len(Trim(arguments.Institution2_Document_Date)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution2_Enrollment_Units#" cfsqltype="CF_SQL_INT" null="#IIf(Len(Trim(arguments.Institution2_Enrollment_Units)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution2_Enrollment_Attendance_Level#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Institution2_Enrollment_Attendance_Level)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution2_Enrollment_Degree_Level#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Institution2_Enrollment_Degree_Level)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution2_Performance_Credits#" cfsqltype="CF_SQL_INT" null="#IIf(Len(Trim(arguments.Institution2_Performance_Credits)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution2_Performance_GPA#" cfsqltype="CF_SQL_INT" null="#IIf(Len(Trim(arguments.Institution2_Performance_GPA)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution3_ID#" cfsqltype="CF_SQL_INTEGER" null="#IIf(Len(Trim(arguments.Institution3_ID)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution3_Document_Date#" cfsqltype="CF_SQL_DATE" null="#IIf(Len(Trim(arguments.Institution3_Document_Date)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution3_Enrollment_Units#" cfsqltype="CF_SQL_INT" null="#IIf(Len(Trim(arguments.Institution3_Enrollment_Units)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution3_Enrollment_Attendance_Level#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Institution3_Enrollment_Attendance_Level)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution3_Enrollment_Degree_Level#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Institution3_Enrollment_Degree_Level)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution3_Performance_Credits#" cfsqltype="CF_SQL_INT" null="#IIf(Len(Trim(arguments.Institution3_Performance_Credits)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Institution3_Performance_GPA#" cfsqltype="CF_SQL_INT" null="#IIf(Len(Trim(arguments.Institution3_Performance_GPA)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Approval_Date#" cfsqltype="CF_SQL_DATE" null="#IIf(Len(Trim(arguments.Approval_Date)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Payment_Submitted_Date#" cfsqltype="CF_SQL_DATE" null="#IIf(Len(Trim(arguments.Payment_Submitted_Date)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Payment_Date#" cfsqltype="CF_SQL_DATE" null="#IIf(Len(Trim(arguments.Payment_Date)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Payment_Type#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Payment_Type)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Payment_Amount#" cfsqltype="CF_SQL_INT" null="#IIf(Len(Trim(arguments.Payment_Amount)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Payment_Reference#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.Payment_Reference)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Notes#" cfsqltype="CF_SQL_LONGVARCHAR" null="#IIf(Len(Trim(arguments.Notes)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.Date_Created#" cfsqltype="CF_SQL_TIMESTAMP" null="#IIf(Len(Trim(arguments.Date_Created)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.authorized#" cfsqltype="CF_SQL_BIT" null="#IIf(NOT IsBoolean(arguments.authorized), true, false)#" />
			<cfprocparam value="#arguments.cohort#" cfsqltype="CF_SQL_INTEGER" null="#IIf(NOT IsNumeric(arguments.cohort), true, false)#" />
			<cfprocparam value="#arguments.scholarshipType#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.scholarshipType)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.scholarshipTypes#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.scholarshipTypes)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.term#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.term)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.termType#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.termType)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.verificationType#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.verificationType)) eq 0, true, false)#" />
			<cfprocparam value="#arguments.statuses#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(arguments.statuses)) eq 0, true, false)#" />
			<cfprocresult name="recs" />
		</cfstoredproc>
		<cfreturn recs />
	</cffunction>

	<cffunction name="save" access="public" output="false" returntype="any">
		<cfargument name="payment" required="true" type="assets.calgrants.com.bo.Payment" />

		<cfstoredproc datasource="#getDatasource()#" procedure="savePayment">
			<cfprocparam value="#payment.getPayment_ID()#" cfsqltype="CF_SQL_INTEGER" variable="id" type="inout" null="false" />
			<cfprocparam value="#payment.getScholarship_ID()#" cfsqltype="CF_SQL_INTEGER" null="false" />
			<cfprocparam value="#payment.getPayment_Schedule_ID()#" cfsqltype="CF_SQL_INTEGER" null="false" />
			<cfprocparam value="#payment.getDeleted()#" cfsqltype="CF_SQL_BIT" null="false" />
			<cfprocparam value="#payment.getOpt_Out()#" cfsqltype="CF_SQL_BIT" null="false" />
			<cfprocparam value="#payment.getOpt_Out_Reason()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(payment.getOpt_Out_Reason())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getInstitution1_ID()#" cfsqltype="CF_SQL_INTEGER" null="false" />
			<cfprocparam value="#payment.getInstitution1_Document_Date()#" cfsqltype="CF_SQL_DATE" null="#IIf(Len(Trim(payment.getInstitution1_Document_Date())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getInstitution1_Enrollment_Units()#" cfsqltype="CF_SQL_INT" null="#IIf(Len(Trim(payment.getInstitution1_Enrollment_Units())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getInstitution1_Enrollment_Attendance_Level()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(payment.getInstitution1_Enrollment_Attendance_Level())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getInstitution1_Enrollment_Degree_Level()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(payment.getInstitution1_Enrollment_Degree_Level())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getInstitution1_Performance_Credits()#" cfsqltype="CF_SQL_INT" null="#IIf(Len(Trim(payment.getInstitution1_Performance_Credits())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getInstitution1_Performance_GPA()#" cfsqltype="CF_SQL_INT" null="#IIf(Len(Trim(payment.getInstitution1_Performance_GPA())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getInstitution2_ID()#" cfsqltype="CF_SQL_INTEGER" null="false" />
			<cfprocparam value="#payment.getInstitution2_Document_Date()#" cfsqltype="CF_SQL_DATE" null="#IIf(Len(Trim(payment.getInstitution2_Document_Date())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getInstitution2_Enrollment_Units()#" cfsqltype="CF_SQL_INT" null="#IIf(Len(Trim(payment.getInstitution2_Enrollment_Units())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getInstitution2_Enrollment_Attendance_Level()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(payment.getInstitution2_Enrollment_Attendance_Level())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getInstitution2_Enrollment_Degree_Level()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(payment.getInstitution2_Enrollment_Degree_Level())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getInstitution2_Performance_Credits()#" cfsqltype="CF_SQL_INT" null="#IIf(Len(Trim(payment.getInstitution2_Performance_Credits())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getInstitution2_Performance_GPA()#" cfsqltype="CF_SQL_INT" null="#IIf(Len(Trim(payment.getInstitution2_Performance_GPA())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getInstitution3_ID()#" cfsqltype="CF_SQL_INTEGER" null="false" />
			<cfprocparam value="#payment.getInstitution3_Document_Date()#" cfsqltype="CF_SQL_DATE" null="#IIf(Len(Trim(payment.getInstitution3_Document_Date())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getInstitution3_Enrollment_Units()#" cfsqltype="CF_SQL_INT" null="#IIf(Len(Trim(payment.getInstitution3_Enrollment_Units())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getInstitution3_Enrollment_Attendance_Level()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(payment.getInstitution3_Enrollment_Attendance_Level())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getInstitution3_Enrollment_Degree_Level()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(payment.getInstitution3_Enrollment_Degree_Level())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getInstitution3_Performance_Credits()#" cfsqltype="CF_SQL_INT" null="#IIf(Len(Trim(payment.getInstitution3_Performance_Credits())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getInstitution3_Performance_GPA()#" cfsqltype="CF_SQL_INT" null="#IIf(Len(Trim(payment.getInstitution3_Performance_GPA())) eq 0, true, false)#" />
			<cfprocparam value="#formatShortDate(payment.getApproval_Date())#" cfsqltype="CF_SQL_DATE" null="#IIf(Len(Trim(payment.getApproval_Date())) eq 0, true, false)#" />
			<cfprocparam value="#formatShortDate(payment.getPayment_Submitted_Date())#" cfsqltype="CF_SQL_DATE" null="#IIf(Len(Trim(payment.getPayment_Submitted_Date())) eq 0, true, false)#" />
			<cfprocparam value="#formatShortDate(payment.getPayment_Date())#" cfsqltype="CF_SQL_DATE" null="#IIf(Len(Trim(payment.getPayment_Date())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getPayment_Type()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(payment.getPayment_Type())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getPayment_Amount()#" cfsqltype="CF_SQL_INT" null="#IIf(Len(Trim(payment.getPayment_Amount())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getPayment_Reference()#" cfsqltype="CF_SQL_VARCHAR" null="#IIf(Len(Trim(payment.getPayment_Reference())) eq 0, true, false)#" />
			<cfprocparam value="#payment.getNotes()#" cfsqltype="CF_SQL_LONGVARCHAR" null="#IIf(Len(Trim(payment.getNotes())) eq 0, true, false)#" />
		</cfstoredproc>
		<cfreturn id />
	</cffunction>

	<cffunction name="destroy" access="public" output="false" returntype="any">
		<cfargument name="Payment_ID" required="true" />

		<cfstoredproc datasource="#getDatasource()#" procedure="destroyPayment">
			<cfprocparam value="#arguments.Payment_ID#" cfsqltype="CF_SQL_INTEGER" null="false" />
			<cfprocparam value="true" cfsqltype="CF_SQL_BIT" null="false" />
		</cfstoredproc>
		<cfreturn true />
	</cffunction>

</cfcomponent>

